﻿-- ===============================================================================================
-- Basic View for Countries
-- ===============================================================================================

IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[esf_sso].[VCountry]'))
	DROP VIEW [esf_sso].[VCountry]
GO

-- SELECT * FROM [esf_sso].[VCountry]

CREATE VIEW [esf_sso].[VCountry] AS
	SELECT * FROM esf_sso.VBasicReference WHERE BasicReferenceTypeID = 8
	
GO 